2014-01-17 -10792 - Spec - ARUN Optimization #ARUN #US
SPECIFICATIONS
10792 - Spec - ARUN Optimization
Purpose
Find ways to optimize ARUN performance.
Admin Info
Purpose
|
Find ways to optimize ARUN performance
|
Requested By
|
Daniel Brennan
|
Spec Created By
|
Surya Basa
|
Spec Created Date
|
02/26/2014
|
Spec QA by
|
Surya Basa
|
Objects
|
/AFS/ARUN_BATCH
/AFS/ARUN_PARALLEL
|
Document Status
|
WIP
|
References
Prior Tickets
2012-07-26 - 4614.100 - Spec - Allocation Optimization
Documents
N/A
Functional Requirement
The ARUN job runs longer and bumps into the delivery job at times thereby resulting in the deliveries created next day or at times the deliveries are dropped late. The selection sets need to be reviewed along with other possible options to optimize performance.
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
The solution involves -
1. Reviewing the selection set criteria to optimize performance.
2. Evaluate PARALLEL ARUN option to optimize performance.
3. Review running variants created with different ARUN types at the same time rather than in a single job.
4. Review combining selection sets with same criteria into one.
5. Include the delivery creation variant as the last step in the ARUN job.
Test Plan
[List test scenarios/cases to be executed here]
Test Scenario
|
Expected Results
|
1. Run batch ARUN with NA STK & NA PRG variants in background
2. Run batch ARUN with NA STK & NA PRG variants in background by removing the exclusion criteria in the selection sets
3. Run parallel ARUN with NA STK & NA PRG variants in background
4. Run parallel ARUN with NA STK & NA PRG variants in background by removing the exclusion criteria in the selection sets
5. Run parallel ARUN with NA STK and NA PRG varaints in background simultaneously
6. Run parallel ARUN in background by combining the selection sets with similar criteria that are created with the same ARUN type
|
1. The job should complete successfully and generate ARUN numbers for the two variants and allocate the sales orders having matching criteria
2. The duration while running the job with the inclusion criteria should be better than with the inclusion criteria.
3. Parallel ARUN should do better than Batch ARUN.
4. The duration should be comparatively better with exclusion criteria when compared to inclusion criteria.
5. The ARUN results should be consistent as those of the individual jobs.
6. The ARUN results should be consistent as those of the individual jobs/selection sets.
|
Solution Details
[Provide complete technical details for configuration or programming here]
1. The selection set criteria has to be modified if feasible to remove the exclusion criteria like seasons, document types and delivery status indicator and maintain inclusion criteria only to optimize ARUN performance.
2. Parallel ARUN should be preferred to batch ARUN for better performance.
3. The long time taking variants like STK and PRG should be run simultaneously in separate jobs to save time.
4. The MTO selection sets created with Z004 ARUN type should be combined into one selection set to save time.
5. Create new selection sets/variants with parallel ARUN.
SAP recommended Solutions-
1. Modify the database to improve ARUN and overall system performance
2. Increase the memory size on the lock table so that table lock overflow does not occur in parallel ARUN
3. Create a new index on VBAP to improve ARUN performance
4. Implement OSS note 1975934 to improve ARUN performance
Issues
N/A